All Questions

I need to generate statistics for different types of disabilities and count how many women, who started suffering from each condition in 2018, were affected during each week of January (first month of ...

I have a table with hierarchy v_name **id: name: child_id** 1000 abc null 1001 bac 1000 1002 cab 1001 1003 lop 1001 1004 jui null 1005 njj 1004 Now we are ...

I have two Common Table Expressions (CTEs) in an Oracle SQL query. Both CTEs (CTE_CID and CTE_BEN_DT) return results quickly when executed separately. However, when I join them and add a WHERE clause, ...

The STG_USR_ACCSS table has more than 25 billion rows. Creating a view by joining other tables, when we query the data from the view, it's taking forever to return the results. Please help me to ...

I have an Oracle table that contains a lot of data that is separated into partitions by COLUMN1 (VARCHAR2). This table also has COLUMN2 (DATE). There is an index (with same partitions as the main ...

I have a table with 36 million record and I need to update fields on some conditions but it is taking 10 min for each query and I have many queries to run : MERGE INTO account USING ( SELECT id,...

I have a non-clustered index on this column (TOM) in this table (SP_ORD_1PC_PASS). This query returns instantly: SELECT MAX(TOM) FROM SP_ORD_1PC_PASS This query also returns instantly: SELECT MIN(TOM)...

I'm currently working on a C# project where I need to retrieve data from an Oracle 19 database. I'm using Entity Framework to handle the database queries. However, I've noticed a significant ...

I have noticed in the database some blocks, the event was read by other session, I have identified the table and the index causing that. However I have noticed the table statistics are 3 month old ...

I've a below select Query which is taking lot of time when data is huge. It is a join from 4 diffrent tables and I want to create a view for it. I'm not able to find any optimizing techniques to make ...

I am currently facing performance issues with an Oracle stored procedure that performs a MERGE operation between two tables. The purpose of this procedure is to archive changes from one table to ...

The question is: Is that possible? Or, because of bitmap_construct_agg returns BLOB or RAW it is not possible at all? This is my test case: create table testmvb(id number, subid number); create ...

I have 2 different schemas installed on the same Oracle server (v12c). On each of these 2 schemas, I have the same DB LINK which points to a distant database which allows me to read a table (size ±12,...

Given the following table structure: Table A a 1 2 3 Table AB a b 1 1 1 2 1 3 2 1 2 2 3 2 3 3 Table B b 1 2 3 Problem description: Given a list of b's, I want to query those a's which are associated ...

Create or Replace package SamplePackage As Cursor cur is select * from abc; refCurParam as ref cursor return cur%rowtype; Begin End SamplePackage; The above package used in SP in order to define type ...